import openpyxl

workbook = openpyxl.load_workbook("景点天气.xlsx")
print(type(workbook.sheetnames))
sheet = workbook.sheetnames[1]
print("sheet=", sheet, "type", type(sheet))
# worksheet = workbook.get_sheet_by_name("景点天气")
worksheet = workbook["景点天气"]
print("worksheet", type(worksheet), worksheet)
lst = []
for row in worksheet.rows:
    sub_list = []
    for cell in row:
        sub_list.append(cell.value)
    lst.append(sub_list)
print(lst)
